home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Excel for Windows 95 Bible by John Walkenbach
/
Excel For Windows 95 Bible by John Walkenbach (IDG Books) (1-56884-495-6)(1995).ISO
/
xl_sw
/
amrt_sch
/
gener8.txt
next >
Wrap
Text File
|
1995-05-27
|
5KB
|
110 lines
Gener8.xlm 1.2 for Microsoft Excel versions 4 and 5
Generate Great Amortization Schedules
This Microsoft Excel macro application will generate great
fixed rate and variable rate loan schedules. It allows for
variable interest rates and extra principal payments. For
"variable rate loans, it can project a worst-case interest
rate change based on the loan's" maximum rate and maximum
increase per adjustment period. It allows all components
of the monthly payment (insurance, taxes, etc...) to be
changed at any point in the loan." The amortization
schedules show annual totals for interest and principal
paid and show graphically how the interest and principal
vary over the life of the loan. Generated spreadsheets are
complete and functional but not customizable without the
password provided through registration ($10).
How to use Gener8.xlm:
Gener8.xlm is a Microsoft Excel macro that runs
automatically when opened by Excel. Gener8.xlm can also
be re-started during the same Excel session by pressing
Ctrl-Shift-A.
When you start Gener8.xlm, you will see an introductory
screen. Select "Generate a Schedule" to go on to the
input screen. The input screen is used to provide basic
information about the loan (length, rate, etc...). Please
note that you can not enter any data into the variable
rate related fields unless you select the variable rate
option. When you have all fields completed and select "OK"
the macro will generate a loan schedule and a graph based
on the information provided.
Gener8.xlm is functional in it distributed shareware form.
If you would like to have greater control over the
spreadsheets that it generates, you will need to register
the product. There are 3 levels of registration available:
Level 1: $10.00 You will receive the password and
instructions for unprotecting the generated
spreadsheets. If you are going to generate a few
schedules but still need to change their appearance,
this is the best way to go.
Level 2: $20.00 You will receive the commercial (non-
shareware) version of this product. The commercial
version generates unprotected spreadsheets and does
not have an opening shareware notice. For this level
of registration the macro source code is still
password protected. If you are going to generate a
lot of schedules and the format of the schedules
closely matches your business needs, this is the best
way to go.
Level 3: $50.00 You will receive the commercial (non-
shareware) version of this product without password
protection on the macro itself. This will allow you
to have complete control over how the spreadsheets are
generated. You will be able to modify the macro source
code to customize the generated spreadsheets for your
business. If you need to generate a lot of schedules
and you need them customized for your business, this is
the best way to go.
To register this product, send the appropriate registration
amount to:
Ohio Star Software
Gener8.xlm 1.2 Registration
8919 Deep Forest Ln.
Centerville, OH 45458
For faster service with level 1 registrations, mail the $10.00
check to the address below and send us an e-mail message saying
"the check is in the mail for Gener8 1.2". We will reply to
your e-mail with the password and instructions to unprotect the
generated schedules and wait for your check to arrive.
E-Mail Addresses:
Compuserve ID: 70412,2455
Internet: 70412.2455@Compuserve.COM
Complete the information below and print this page
Gener8.xlm 1.2 Registration Information
Name:
Address:
City: State: Zip:
Please mark the registration level
Level 1: $10.00 Password to unprotect
generated spreadsheets
Level 2: $20.00 Generate unprotected
spreadsheets
Level 3: $50.00 Source code for Gener8.xlm
application macro
If level 2 or 3, please circle diskette size preferred:
3 1/2 5 1/4